﻿CREATE TABLE [dbo].[tblCustomerRef] (
    [CCCustomerNumber] CHAR (20)     NOT NULL,
    [LocationID]       INT           NOT NULL,
    [CustomerNumber]   INT           NULL,
    [ImportDate]       SMALLDATETIME NULL,
    PRIMARY KEY CLUSTERED ([CCCustomerNumber] ASC, [LocationID] ASC) WITH (FILLFACTOR = 90, ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Defines the customer based on the call center''s customer ID.', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'tblCustomerRef';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'The customer number assigned by the call center.', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'tblCustomerRef', @level2type = N'COLUMN', @level2name = N'CCCustomerNumber';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Location ID for the call center.  Links to vdn_MSTCallCenter.', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'tblCustomerRef', @level2type = N'COLUMN', @level2name = N'LocationID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'The customer number assigned by VBI.', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'tblCustomerRef', @level2type = N'COLUMN', @level2name = N'CustomerNumber';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'The date the record was imported into the table.', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'tblCustomerRef', @level2type = N'COLUMN', @level2name = N'ImportDate';

